create external table jms_ods.yl_oms_order_tb_exporder_hi
(
  ID                   bigint             comment '主键id'
  INPUT_TIME           date               comment '订单录入时间'
  MAIL_NO              string             comment '物流运单号'
  update_time          string                comment '更新时间'
)PARTITIONED BY (
   `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd--hh)')
  stored as parquet
 LOCATION
   '/dw/hive/jms_ods.db/external/yl_oms_order_tb_exporder_hi'
 TBLPROPERTIES (
   'parquet.column.index.access'='true'
 )
